SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[GetMemberByUserName]
@Username nvarchar(50)
AS
SELECT TOP 1 * FROM vMember WHERE UserName = @Username;
GO
